MFG Salesforce Customers System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
Module | Description |
---|---|
create-contact-request | Salesforce Contact create mapping |
lookup-contacts-response | Salesforce Contact to CIM Individual mapping response |
map-contact-points-for-contact | Salesforce Contact Points for Contacts mapping |
retrieve-contact-by-id-response | Salesforce Contact to CIM Individual format mapping |
update-contact-request-for-sf | Salesforce Contact update mapping |
create-account-contact-relation | Salesforce Create AccountContactRelation mapping |
create-customer-request | Salesforce Person Account create mapping |
create-organization-account-request | Salesforce Organization Account create mapping |
map-contactpoints-for-customer | Salesforce Customer's Contact Points mapping |
retrieve-customer-by-id-response | Salesforce Person Account to CIM Customer format mapping |
retrieve-related-contacts-by-customerid-response | Salesforce AccountContactRelation mapping to CIM PartyRelatedParty |
search-customers-response | Salesforce Account to CIM Customer format mapping response |
update-account-contact-relation | Salesforce Update AccountContactRelation mapping |
update-customers-request-for-sf | Salesforce Person Account update mapping |
update-organization-account-request-for-sf | Salesforce Organization Account update mapping |
create-contact-request
Salesforce Contact create mapping
Source:
./src/main/resources/dwl/contacts/create-contact-request.dwl
Mapping Tables
Maps CIM Individual format to Salesforce Contact Object
Salesforce Contact | CIM | Description |
---|---|---|
Salutation | salutation | The salutation of the contact |
FirstName | firstName | The First Name of the contact |
lastName | LastName | The Last Name of the contact |
BirthDate | birthDate | The birth date of the contact |
Global_Individual_Id__c | externalIds.externalId | The identifier of the contact in MDM system |
MailingStreet | contactPointAddress.addressLine1 | The mailing Address of the contact |
MailingCity | contactPointAddress.cityName | The mailing city of the contact |
MailingPostalCode | contactPointAddress.postalCodeText | The mailing postal code of the contact |
MailingState | contactPointAddress.stateProvinceName | The contact mailing state |
MailingCountry | contactPointAddress.countryName | The contact mailing country |
MailingLatitude | contactPointAddress.geoLatitude | The contact geo latitude location |
MailingLongitude | contactPointAddress.geoLongitude | The contact geo longitude location |
ContactPointEmail.emailAddress | The contact email | |
Phone | ContactPointPhone.telephoneNumber | The contact phone Number |
lookup-contacts-response
Salesforce Contact to CIM Individual mapping response
Source:
./src/main/resources/dwl/contacts/lookup-contacts-response.dwl
Mapping Tables
Maps Salesforce Contact to CIM Individual format
CIM | Salesforce Contact | Description |
---|---|---|
id | Id | The identifier of the contact in Salesforce |
salutation | Salutation | The salutation of the contact |
personName | Name | The name of the contact |
firstName | FirstName | The first name of the contact |
lastName | LastName | The Last name of the contact |
birthDate | Birthdate | The birth date of the contact |
partyType | Individual | The contact party set as "Individual" |
contactPointType | ContactPointAddress | contactPointType set as "ContactPointAddress" |
ContactPointAddress.id | null | The contactPointAddress id set as null |
ContactPointAddress.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointAddress.addressLine1 | MailingStreet | The mailing address of the contact |
ContactPointAddress.cityName | MailingCity | The mailing city of the contact |
ContactPointAddress.postalCodeText | MailingPostalCode | The contact mailing postal code |
ContactPointAddress.stateProvinceName | MailingState | The contact state province name |
ContactPointAddress.countryName | MailingCountry | The country name of the contact |
ContactPointAddress.geoLatitude | MailingLatitude | The geo-latitude code of the contact |
ContactPointAddress.geoLongitude | MailingLongitude | The geo-longitude code of the contact |
ContactPointAddress.geoAccuracy | MailingGeocodeAccuracy | The geo-code accurate location of the contact |
contactPointType | ContactPointEmail | contactPointType set as "ContactPointEmail" |
ContactPointEmail.id | null | The contact point id set as null |
ContactPointEmail.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointEmail.emailAddress | The email address of the contact | |
contactPointType | ContactPointPhone | contactPointType - set as "ContactPointPhone" |
ContactPointPhone.id | null | The contact point id - set as null |
ContactPointPhone.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointPhone.telephoneNumber | Phone | The phone number of the contact |
externalIds.id | id | Id field is hard coded as empty string |
externalIds.externalId | Global_Individual_Id__c | The identifier of the contact in MDM system |
externalIds.externalIdType | MDM | The externalId Type set as "MDM" |
externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
externalIds.status | VALID | The externalId status is set as VALID |
auditInfo.createdDate | CreatedDate | Timestamp of when the contact was created |
auditInfo.createdBy | CreatedBy.Name | Identifies the system or user which created the contact |
auditInfo.updatedDate | LastModifiedDate | Timestamp of when the contact was last updated |
auditInfo.updatedBy | LastModifiedBy.Name | Identifies the system or user which last updated the contact |
auditInfo.isDeleted | IsDeleted | Indicates whether or not the contact has been soft-deleted |
map-contact-points-for-contact
Salesforce Contact Points for Contacts mapping
Source:
./src/main/resources/dwl/contacts/map-contact-points-for-contact.dwl
Mapping Tables
Maps Salesforce Contact to CIM Individual format
CIM | Salesforce Contact | Description |
---|---|---|
contactPointType | ContactPointAddress | contactPointType set as "ContactPointAddress" |
ContactPointAddress.id | null | The contactPointAddress id set as null |
ContactPointAddress.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointAddress.addressLine1 | MailingStreet | The mailing address of the contact |
ContactPointAddress.cityName | MailingCity | The mailing city of the contact |
ContactPointAddress.postalCodeText | MailingPostalCode | The contact mailing postal code |
ContactPointAddress.stateProvinceName | MailingState | The contact state province name |
ContactPointAddress.countryName | MailingCountry | The country name of the contact |
ContactPointAddress.geoLatitude | MailingLatitude | The geo-latitude code of the contact |
ContactPointAddress.geoLongitude | MailingLongitude | The geo-longitude code of the contact |
ContactPointAddress.geoAccuracy | MailingGeocodeAccuracy | The geo-code accurate location of the contact |
contactPointType | ContactPointEmail | contactPointType set as "ContactPointEmail" |
ContactPointEmail.id | null | The contact point id set as null |
ContactPointEmail.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointEmail.emailAddress | The email address of the contact | |
contactPointType | ContactPointPhone | contactPointType - set as "ContactPointPhone" |
ContactPointPhone.id | null | The contact point id - set as null |
ContactPointPhone.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointPhone.telephoneNumber | Phone | The phone number of the contact |
retrieve-contact-by-id-response
Salesforce Contact to CIM Individual format mapping
Source:
./src/main/resources/dwl/contacts/retrieve-contact-by-id-response.dwl
Mapping Tables
Maps Salesforce Contact to CIM Individual format
CIM | Salesforce Contact | Description |
---|---|---|
id | Id | The identifier of the contact in Salesforce |
salutation | Salutation | The salutation of the contact |
personName | Name | The name of the contact |
firstName | FirstName | The first name of the contact |
lastName | LastName | The Last name of the contact |
birthDate | Birthdate | The birth date of the contact |
partyType | Individual | The contact party set as "Individual" |
contactPoints | contactPoints | Contact Points |
externalIds.id | id | Id field is hard coded as empty string |
externalIds.externalId | Global_Individual_Id__c | The identifier of the contact in MDM system |
externalIds.externalIdType | MDM | The externalId Type set as "MDM" |
externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
externalIds.status | VALID | The externalId status is set as VALID |
auditInfo.createdDate | CreatedDate | Timestamp of when the contact was created |
auditInfo.createdBy | CreatedBy.Name | Identifies the system or user which created the contact |
auditInfo.updatedDate | LastModifiedDate | Timestamp of when the contact was last updated |
auditInfo.updatedBy | LastModifiedBy.Name | Identifies the system or user which last updated the contact |
auditInfo.isDeleted | IsDeleted | Indicates whether or not the contact has been soft-deleted |
update-contact-request-for-sf
Salesforce Contact update mapping
Source:
./src/main/resources/dwl/contacts/update-contact-request-for-sf.dwl
Mapping Tables
Maps CIM Individual format to Salesforce Contact Object
Salesforce Contact | CIM | Description |
---|---|---|
Id | contactId | The identifier of the contact in Salesforce |
Salutation | salutation | The salutation of the contact |
FirstName | firstName | The First Name of the contact |
lastName | LastName | The Last Name of the contact |
BirthDate | birthDate | The birth date of the contact |
Global_Individual_Id__c | externalIds.externalId | The identifier of the contact in MDM system |
MailingStreet | contactPointAddress.addressLine1 | The mailing Address of the contact |
MailingCity | contactPointAddress.cityName | The mailing city of the contact |
MailingPostalCode | contactPointAddress.postalCodeText | The mailing postal code of the contact |
MailingState | contactPointAddress.stateProvinceName | The contact mailing state |
MailingCountry | contactPointAddress.countryName | The contact mailing country |
MailingLatitude | contactPointAddress.geoLatitude | The contact geo latitude location |
MailingLongitude | contactPointAddress.geoLongitude | The contact geo longitude location |
ContactPointEmail.emailAddress | The contact email | |
Phone | ContactPointPhone.telephoneNumber | The contact phone Number |
create-account-contact-relation
Salesforce Create AccountContactRelation mapping
Source:
./src/main/resources/dwl/customers/create-account-contact-relation.dwl
Mapping Tables
Maps CIM PartyRelatedParty to Salesforce AccountContactRelation
Salesforce | CIM | Description |
---|---|---|
Id | accountContactRelation.Id | The identifier of the AccountContactRelation record in Salesforce |
AccountId | customerId | The identifier of the associated Account |
ContactId | contactId | The identifier of the associated contact |
Roles | partyRelationshipType | The Relationship type of Account and Contact |
StartDate | relatedFromDate | The date from which Account and Contact are related |
EndDate | relatedEndDate | The date till which Account and Contact are related |
create-customer-request
Salesforce Person Account create mapping
Source:
./src/main/resources/dwl/customers/create-customer-request.dwl
Mapping Tables
Maps CIM Customer format to Salesforce Person Account Object
Salesforce Person Account | CIM | Description |
---|---|---|
Salutation | party.salutation | The salutation of the customer |
FirstName | party.firstName | The First Name of the customer |
lastName | party.LastName | The Last Name of the customer |
PersonBirthDate | party.birthDate | The birth date of the customer |
Global_Customer_Id__c | externalIds.externalId | The Global-Id of the customer when externalIdType matches MDM |
RecordTypeId | recordTypeId | The Salesforce record Id for creating a customer |
AccountNumber | customerNumber | The customer Account Number |
SAP_4HANA_Id__c | externalIds.externalId | SAP4HANA Id of the Customer externalIdType matches SAP_4HANA |
PersonMailingStreet | party.contactPointAddress.addressLine1 | The mailing Address of the customer |
PersonMailingCity | party.contactPointAddress.cityName | The mailing city of the customer |
PersonMailingPostalCode | party.contactPointAddress.postalCodeText | The mailing postal code of the customer |
PersonMailingState | party.contactPointAddress.stateProvinceName | The customer mailing state |
PersonMailingCountry | party.contactPointAddress.countryName | The customer mailing country |
PersonMailingLatitude | party.contactPointAddress.geoLatitude | The customer geo latitude location |
PersonMailingLongitude | party.contactPointAddress.geoLongitude | The customer geo longitude location |
PersonEmail | party.ContactPointEmail.emailAddress | The customer contact email |
Phone | party.ContactPointPhone.telephoneNumber | The customer contact phone Number |
ParentId | payload.primaryAccount | The customers Parent Id |
create-organization-account-request
Salesforce Organization Account create mapping
Source:
./src/main/resources/dwl/customers/create-organization-account-request.dwl
Mapping Tables
Maps CIM Customer format to Salesforce Person Account Object
Salesforce Person Account | CIM | Description |
---|---|---|
Name | party.name | The Name of the Organization |
Global_Customer_Id__c | externalIds.externalId | The Global-Id of the customer when externalIdType matches MDM |
RecordTypeId | recordTypeId | The Salesforce record Id for creating a customer |
AccountNumber | customerNumber | The customer Account Number |
SAP_4HANA_Id__c | externalIds.externalId | SAP4HANA Id of the Customer externalIdType matches SAP_4HANA |
BillingStreet | party.contactPointAddress.addressLine1 | The mailing Address of the customer |
BillingCity | party.contactPointAddress.cityName | The mailing city of the customer |
BillingPostalCode | party.contactPointAddress.postalCodeText | The mailing postal code of the customer |
BillingState | party.contactPointAddress.stateProvinceName | The customer mailing state |
BillingCountry | party.contactPointAddress.countryName | The customer mailing country |
BillingLatitude | party.contactPointAddress.geoLatitude | The customer geo latitude location |
BillingLongitude | party.contactPointAddress.geoLongitude | The customer geo longitude location |
Phone | party.ContactPointPhone.telephoneNumber | The customer contact phone Number |
ParentId | payload.primaryAccount | The customers Parent Id |
map-contactpoints-for-customer
Salesforce Customer's Contact Points mapping
Source:
./src/main/resources/dwl/customers/map-contactpoints-for-customer.dwl
Mapping Tables
Maps Salesforce Contact to CIM Individual format
CIM | Salesforce Contact | Description |
---|---|---|
contactPointType | ContactPointAddress | contactPointType set as "ContactPointAddress" |
ContactPointAddress.id | null | The contactPointAddress id set as null |
ContactPointAddress.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointAddress.addressLine1 | MailingStreet | The mailing address of the contact |
ContactPointAddress.cityName | MailingCity | The mailing city of the contact |
ContactPointAddress.postalCodeText | MailingPostalCode | The contact mailing postal code |
ContactPointAddress.stateProvinceName | MailingState | The contact state province name |
ContactPointAddress.countryName | MailingCountry | The country name of the contact |
ContactPointAddress.geoLatitude | MailingLatitude | The geo-latitude code of the contact |
ContactPointAddress.geoLongitude | MailingLongitude | The geo-longitude code of the contact |
ContactPointAddress.geoAccuracy | MailingGeocodeAccuracy | The geo-code accurate location of the contact |
contactPointType | ContactPointEmail | contactPointType set as "ContactPointEmail" |
ContactPointEmail.id | null | The contact point id set as null |
ContactPointEmail.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointEmail.emailAddress | The email address of the contact | |
contactPointType | ContactPointPhone | contactPointType - set as "ContactPointPhone" |
ContactPointPhone.id | null | The contact point id - set as null |
ContactPointPhone.activeFromDate | now() | The date from which the contact point is active - Set as current date |
ContactPointPhone.telephoneNumber | Phone | The phone number of the contact |
retrieve-customer-by-id-response
Salesforce Person Account to CIM Customer format mapping
Source:
./src/main/resources/dwl/customers/retrieve-customer-by-id-response.dwl
Mapping Tables
Maps Salesforce Account to CIM Customer format The CIM Customer (PartyRole) can have either Individual or Organization as Party. The Salesforce PersonAccount is mapped as a Customer with Party as Individual in CIM. The Salesforce Account is mapped as a Customer with Party as Organization in CIM.
CIM | Salesforce Person Account | Description |
---|---|---|
partyRoleType | Customer | Hard coded party role to customer |
id | Id | The customer Id |
party.id | Id | The party Id is hard coded to null |
party.salutation | Salutation | The customer salutation |
party.personName | FirstName ++ LastName | The customer personal name (concatenate FistName + LastName) |
party.firstName | FirstName | The customer first name |
party.lastName | LastName | The customer Last name |
party.birthDate | PersonBirthdate | The customer birth date |
party.partyType | Individual | The customer party type hard coded as Individual or Organization |
party.contactPoints | contactPoints | Contact Points |
externalIds.id | id | Id field is hard coded as empty string |
externalIds.externalId | Global_Customer_Id__c | The customer Global Id |
externalIds.externalIdType | MDM | The customer is hard coded as MDM |
externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
externalIds.status | VALID | The customer status is hard coded as VALID |
auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
auditInfo.createdBy | CreatedBy.Name | The last created by user name |
auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
customerNumber | AccountNumber | The customer Account Number |
customerStatus | ACTIVE | Hard coded as ACTIVE |
retrieve-related-contacts-by-customerid-response
Salesforce AccountContactRelation mapping to CIM PartyRelatedParty
Source:
./src/main/resources/dwl/customers/retrieve-related-contacts-by-customerid-response.dwl
Variables
var s
Maps Salesforce AccountContactRelation to CIM PartyRelatedParty
Mapping Tables
Maps Salesforce AccountContactRelation to CIM PartyRelatedParty
CIM | Salesforce | Description |
---|---|---|
id | Id | The identifier of the AccountContactRelation record in Salesforce |
partyRelationshipType | Roles | The Relationship type of Account and Contact |
relatedParty.id | ContactId | The identifier of the associated contact |
relatedParty.partyType | "Individual" | The type of Party set as Individual |
party.id | AccountId | The identifier of the associated Account |
party.partyType | "Organization" | The type of Party set as Organization |
relatedFromDate | StartDate | The date from which Account and Contact are related |
relatedEndDate | EndDate | The date till which Account and Contact are related |
search-customers-response
Salesforce Account to CIM Customer format mapping response
Source:
./src/main/resources/dwl/customers/search-customers-response.dwl
Mapping Tables
Maps Salesforce Account to CIM Customer format The CIM Customer (PartyRole) can have either Individual or Organization as Party. The Salesforce PersonAccount is mapped as a Customer with Party as Individual in CIM. The Salesforce Account is mapped as a Customer with Party as Organization in CIM.
CIM | Salesforce Person Account | Description |
---|---|---|
partyRoleType | Customer | Hard coded party role to customer |
id | Id | The customer Id |
party.id | id | The party Id is hard coded to null |
party.salutation | Salutation | The customer salutation |
party.personName | FirstName ++ LastName | The customer personal name (concatenate FistName + LastName) |
party.firstName | FirstName | The customer first name |
party.lastName | LastName | The customer Last name |
party.birthDate | PersonBirthdate | The customer birth date |
party.partyType | Individual | The customer party type hard coded as Individual or Organization |
contactPointType | ContactPointAddress | Hard coded customer contact type to ContactPointAddress |
ContactPointAddress.id | null | The customer Id |
ContactPointAddress.activeFromDate | today's date | The customer Active from date is hard coded to today's date |
ContactPointAddress.addressLine1 | PersonMailingStreet | The customers mailing address |
ContactPointAddress.cityName | PersonMailingCity | The customers mailing city |
ContactPointAddress.postalCodeText | PersonMailingPostalCode | The customer mailing postal code |
ContactPointAddress.stateProvinceName | PersonMailingState | The customer state province name |
ContactPointAddress.countryName | PersonMailingCountry | The customer country name |
ContactPointAddress.geoLatitude | PersonMailingLatitude | The customer geo-latitude code |
ContactPointAddress.geoLongitude | PersonMailingLongitude | The customer geo-longitude code |
ContactPointAddress.geoAccuracy | PersonMailingGeocodeAccuracy | The customer geo-code accurate location |
contactPointType | ContactPointEmail | Hard coded customer contact type to ContactPointEmail |
ContactPointEmail.id | null | The customer id |
ContactPointEmail.activeFromDate | today's date | The customer Active from date is hard coded to today's date |
ContactPointEmail.emailAddress | PersonEmail | The customer contact email address |
contactPointType | ContactPointPhone | Hard coded customer contact type to ContactPointPhone |
ContactPointPhone.id | null | The customer id |
ContactPointPhone.activeFromDate | today's date | The customer Active from date is hard coded to today's date |
ContactPointPhone.telephoneNumber | Phone | The customer phone number |
externalIds.id | id | Id field is hard coded as empty string |
externalIds.externalId | Global_Customer_Id__c | The customer Global Id |
externalIds.externalIdType | MDM | The customer is hard coded as MDM |
externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
externalIds.status | VALID | The customer status is hard coded as VALID |
auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
auditInfo.createdBy | CreatedBy.Name | The last created by user name |
auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
customerNumber | AccountNumber | The customer Account Number |
customerStatus | ACTIVE | Hard coded as ACTIVE |
update-account-contact-relation
Salesforce Update AccountContactRelation mapping
Source:
./src/main/resources/dwl/customers/update-account-contact-relation.dwl
Mapping Tables
Maps CIM PartyRelatedParty to Salesforce AccountContactRelation
Salesforce | CIM | Description |
---|---|---|
Id | accountContactRelation.id | The identifier of the AccountContactRelation record in Salesforce |
Roles | partyRelationshipType | The Relationship type of Account and Contact |
StartDate | relatedFromDate | The date from which Account and Contact are related |
EndDate | relatedEndDate | The date till which Account and Contact are related |
update-customers-request-for-sf
Salesforce Person Account update mapping
Source:
./src/main/resources/dwl/customers/update-customers-request-for-sf.dwl
Mapping Tables
Maps CIM format to Salesforce Account Object
Salesforce Person Account | CIM | Description |
---|---|---|
Id | customerId | The customer Id from the Uriparams |
Salutation | party.salutation | The salutation of the customer |
FirstName | party.firstName | The First Name of the customer |
lastName | party.LastName | The Last Name of the customer |
PersonBirthDate | party.birthDate | The birth date of the customer |
AccountNumber | customerNumber | The customer Account Number |
Global_Customer_Id__c | externalIds.externalId | The Global-Id of the customer when externalIdType matches MDM |
SAP_4HANA_Id__c | externalIds.externalId | SAP4HANA Id of the Customer externalIdType matches SAP_4HANA |
PersonMailingStreet | party.contactPointAddress.addressLine1 | The mailing Address of the customer |
PersonMailingCity | party.contactPointAddress.cityName | The mailing city of the customer |
PersonMailingPostalCode | party.contactPointAddress.postalCodeText | The mailing postal code of the customer |
PersonMailingState | party.contactPointAddress.stateProvinceName | The customer mailing state |
PersonMailingCountry | party.contactPointAddress.countryName | The customer mailing country |
PersonMailingLatitude | party.contactPointAddress.geoLatitude | The customer geo latitude location |
PersonMailingLongitude | party.contactPointAddress.geoLongitude | The customer geo longitude location |
PersonEmail | party.ContactPointEmail.emailAddress | The customer contact email |
Phone | party.ContactPointPhone.telephoneNumber | The customer contact phone Number |
ParentId | payload.primaryAccount | The customers Parent Id |
update-organization-account-request-for-sf
Salesforce Organization Account update mapping
Source:
./src/main/resources/dwl/customers/update-organization-account-request-for-sf.dwl
Mapping Tables
Maps CIM format to Salesforce Account Object
Salesforce Person Account | CIM | Description |
---|---|---|
Id | customerId | The Id of the customer |
Name | party.name | The Name of the Organization |
Global_Customer_Id__c | externalIds.externalId | The Global-Id of the customer when externalIdType matches MDM |
SAP_4HANA_Id__c | externalIds.externalId | SAP4HANA Id of the Customer externalIdType matches SAP_4HANA |
AccountNumber | customerNumber | The customer Account Number |
BillingStreet | party.contactPointAddress.addressLine1 | The mailing Address of the customer |
BillingCity | party.contactPointAddress.cityName | The mailing city of the customer |
BillingPostalCode | party.contactPointAddress.postalCodeText | The mailing postal code of the customer |
BillingState | party.contactPointAddress.stateProvinceName | The customer mailing state |
BillingCountry | party.contactPointAddress.countryName | The customer mailing country |
BillingLatitude | party.contactPointAddress.geoLatitude | The customer geo latitude location |
BillingLongitude | party.contactPointAddress.geoLongitude | The customer geo longitude location |
Phone | party.ContactPointPhone.telephoneNumber | The customer contact phone Number |
ParentId | payload.primaryAccount | The customers Parent Id |